Need data on location of purchase
What is the profile of my record collection?
What are the most expensive records and CDs I own?
Which band/artist do I own the most and what is the cost of that?
Which record label do I support the most and which did I spent the most?
Which subgenre costs the most and which one is worth the most?
Is there a difference between autographed and non-authographed records?
What is the breakdown of the format and the cost, min price, median price, and max price?
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Rating | Released | release_id | CollectionFolder | Date Added | Collection Media Condition | Collection Sleeve Condition | Collection Notes | Collection Cost | Collection Autographed | Min | Median | Max | Genre | Subgenre | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 33 | SD 8283 | Yes | Yes | The Yes Album | Atlantic | LP, Album, RE, PR; | NaN | 1971 | 7116823.0 | Vinyl | 7/21/19 20:21 | NaN | NaN | NaN | 5.50 | NaN | 2.25 | 3.87 | 10.00 | Rock | Progressive Rock |
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | NaN | 2017 | 8863478.0 | Vinyl | 12/3/16 11:44 | NaN | NaN | NaN | 15.00 | NaN | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal |
| 2 | 373 | CS 8192 | The Dave Brubeck Quartet | The Dave Brubeck Quartet | Time Out | Columbia | LP, Album | NaN | 1961 | 2676016.0 | Vinyl | 5/5/14 21:16 | NaN | NaN | NaN | 20.00 | NaN | 5.07 | 26.50 | 130.00 | Jazz | Jazz |
| 3 | 142 | SD 3-100 | Yes | Yes | Yessongs | Atlantic | 3xLP, Album | 5.0 | 1973 | 8179158.0 | Vinyl | 4/20/17 19:05 | NaN | NaN | NaN | 5.00 | NaN | 3.95 | 9.99 | 20.00 | Rock | Progressive Rock |
| 4 | 18 | SD 2-908 | Yes | Yes | Tales From Topographic Oceans | Atlantic | 2xLP, Album, Gat | NaN | 1973 | 8535940.0 | Vinyl | 2/22/20 15:50 | NaN | NaN | NaN | 5.50 | NaN | 7.99 | 13.49 | 20.00 | Rock | Progressive Rock |
| 5 | 340 | SD 18122 | Yes | Yes | Relayer | Atlantic | LP, Album, Gat | NaN | 1974 | 755646.0 | Vinyl | 9/6/14 11:59 | NaN | NaN | NaN | 4.00 | NaN | 1.13 | 7.00 | 30.74 | Rock | Progressive Rock |
| 6 | 374 | SD 8245 | King Crimson | King Crimson | In The Court Of The Crimson King An Observati... | Atlantic | LP, Album, RE, PRC | NaN | 1975 | 4254321.0 | Vinyl | 5/5/14 21:14 | NaN | NaN | NaN | 12.00 | NaN | 10.00 | 17.00 | 25.00 | Rock | Progressive Rock |
| 7 | 255 | 34224, PZ 34224 | Kansas (2) | Kansas (2) | Leftoverture | Kirshner, Kirshner | LP, Album | 3.0 | 1976 | 1476710.0 | Vinyl | 8/9/15 18:25 | NaN | NaN | NaN | 0.86 | NaN | 1.72 | 3.82 | 9.95 | Rock | Classic Rock |
| 8 | 341 | SD 19132 | Yes | Yes | Fragile | Atlantic | LP, Album, RE, SRC | NaN | 1977 | 2637700.0 | Vinyl | 9/6/14 11:59 | NaN | NaN | NaN | 4.00 | NaN | 4.50 | 7.25 | 14.00 | Rock | Progressive Rock |
| 9 | 19 | AFL1-3516 | Scorpions | Scorpions | Best Of Scorpions | RCA Victor | LP, Comp | NaN | 1979 | 3632339.0 | Vinyl | 2/22/20 15:47 | NaN | NaN | NaN | 2.00 | NaN | 4.50 | 7.99 | 14.99 | Metal | Heavy Metal |
Some of the labels are separated by commas.
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Rating | Released | release_id | CollectionFolder | Date Added | Collection Media Condition | Collection Sleeve Condition | Collection Notes | Collection Cost | Collection Autographed | Min | Median | Max | Genre | Subgenre | 0 | 1 | 2 | 3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 33 | SD 8283 | Yes | Yes | The Yes Album | Atlantic | LP, Album, RE, PR; | NaN | 1971 | 7116823.0 | Vinyl | 7/21/19 20:21 | NaN | NaN | NaN | 5.50 | NaN | 2.25 | 3.87 | 10.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | NaN | 2017 | 8863478.0 | Vinyl | 12/3/16 11:44 | NaN | NaN | NaN | 15.00 | NaN | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal | Relapse Records | None | None | None |
| 2 | 373 | CS 8192 | The Dave Brubeck Quartet | The Dave Brubeck Quartet | Time Out | Columbia | LP, Album | NaN | 1961 | 2676016.0 | Vinyl | 5/5/14 21:16 | NaN | NaN | NaN | 20.00 | NaN | 5.07 | 26.50 | 130.00 | Jazz | Jazz | Columbia | None | None | None |
| 3 | 142 | SD 3-100 | Yes | Yes | Yessongs | Atlantic | 3xLP, Album | 5.0 | 1973 | 8179158.0 | Vinyl | 4/20/17 19:05 | NaN | NaN | NaN | 5.00 | NaN | 3.95 | 9.99 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 4 | 18 | SD 2-908 | Yes | Yes | Tales From Topographic Oceans | Atlantic | 2xLP, Album, Gat | NaN | 1973 | 8535940.0 | Vinyl | 2/22/20 15:50 | NaN | NaN | NaN | 5.50 | NaN | 7.99 | 13.49 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 5 | 340 | SD 18122 | Yes | Yes | Relayer | Atlantic | LP, Album, Gat | NaN | 1974 | 755646.0 | Vinyl | 9/6/14 11:59 | NaN | NaN | NaN | 4.00 | NaN | 1.13 | 7.00 | 30.74 | Rock | Progressive Rock | Atlantic | None | None | None |
| 6 | 374 | SD 8245 | King Crimson | King Crimson | In The Court Of The Crimson King An Observati... | Atlantic | LP, Album, RE, PRC | NaN | 1975 | 4254321.0 | Vinyl | 5/5/14 21:14 | NaN | NaN | NaN | 12.00 | NaN | 10.00 | 17.00 | 25.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 7 | 255 | 34224, PZ 34224 | Kansas (2) | Kansas (2) | Leftoverture | Kirshner, Kirshner | LP, Album | 3.0 | 1976 | 1476710.0 | Vinyl | 8/9/15 18:25 | NaN | NaN | NaN | 0.86 | NaN | 1.72 | 3.82 | 9.95 | Rock | Classic Rock | Kirshner | Kirshner | None | None |
| 8 | 341 | SD 19132 | Yes | Yes | Fragile | Atlantic | LP, Album, RE, SRC | NaN | 1977 | 2637700.0 | Vinyl | 9/6/14 11:59 | NaN | NaN | NaN | 4.00 | NaN | 4.50 | 7.25 | 14.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 9 | 19 | AFL1-3516 | Scorpions | Scorpions | Best Of Scorpions | RCA Victor | LP, Comp | NaN | 1979 | 3632339.0 | Vinyl | 2/22/20 15:47 | NaN | NaN | NaN | 2.00 | NaN | 4.50 | 7.99 | 14.99 | Metal | Heavy Metal | RCA Victor | None | None | None |
| 10 | 143 | MCA 1688, MCA-1688 | Steely Dan | Steely Dan | Aja | MCA Records, MCA Records | LP, Album, RE | 5.0 | 1980 | 2457672.0 | Vinyl | 4/20/17 19:03 | NaN | NaN | NaN | 5.00 | NaN | 2.00 | 8.99 | 29.95 | Rock | Classic Rock | MCA Records | MCA Records | None | None |
| 11 | 17 | SD 16019 | Yes | Yes | Drama | Atlantic | LP, Album, Gat | NaN | 1980 | 10123561.0 | Vinyl | 2/22/20 15:52 | NaN | NaN | NaN | 4.00 | NaN | 2.00 | 4.55 | 11.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 12 | 149 | 422-811 492-1 M-1, 811492-1 M-1 | Various | Various | Flashdance (Original Soundtrack From The Motio... | Casablanca, Casablanca | LP, Album, 26 | 4.0 | 1983 | 2969044.0 | Vinyl | 4/2/17 18:00 | NaN | NaN | NaN | 2.00 | NaN | 1.00 | 2.60 | 5.49 | Electronic | Synthpop | Casablanca | Casablanca | None | None |
| 13 | 256 | GHS 24099 | Whitesnake | Whitesnake | Whitesnake | Geffen Records | LP, Album | 3.0 | 1987 | 383094.0 | Vinyl | 8/9/15 18:23 | NaN | NaN | NaN | 0.50 | NaN | 5.50 | 9.05 | 21.49 | Rock | Classic Rock | Geffen Records | None | None | None |
| 14 | 275 | RR 6427-2 | The Dillinger Escape Plan | The Dillinger Escape Plan | Calculating Infinity | Relapse Records | CD, Album | NaN | 1999 | 5536513.0 | CD | 6/12/15 18:44 | NaN | NaN | NaN | 1.00 | NaN | 0.86 | 5.51 | 11.99 | Metal | Progressive Metal | Relapse Records | None | None | None |
| 15 | 182 | HH666-52 | Cave In | Cave In | Jupiter | Hydra Head Records | CD, Album | NaN | 2000 | 416414.0 | CD | 9/20/16 18:42 | NaN | NaN | NaN | 2.00 | NaN | 4.02 | 6.85 | 8.91 | Metal | Hardcore | Hydra Head Records | None | None | None |
| 16 | 375 | IPC-32 | Isis (6) | Isis (6) | Oceanic | Ipecac Recordings | CD, Album | NaN | 2002 | 376473.0 | CD | 3/25/14 19:51 | NaN | NaN | NaN | 7.00 | NaN | 4.58 | 6.33 | 12.97 | Metal | Post Metal | Ipecac Recordings | None | None | None |
| 17 | 193 | J1PV-55425-1 | Wyclef Jean | Wyclef Jean | The Preacher's Son | J Records | 2xLP, Promo | NaN | 2003 | 2092873.0 | Vinyl | 6/9/16 11:15 | NaN | NaN | Sell | 0.50 | NaN | 1.88 | 3.88 | 10.00 | Hip Hop | Hip Hop | J Records | None | None | None |
| 18 | 146 | TZ 7092 | Kayo Dot | Kayo Dot | Choirs Of The Eye | Tzadik | CD, Album, Cre | 5.0 | 2003 | 649369.0 | CD | 4/2/17 18:17 | NaN | NaN | NaN | 15.00 | Yes | 6.66 | 10.19 | 16.37 | Metal | Progressive Metal | Tzadik | None | None | None |
| 19 | 264 | EK 93480 | Chevelle (2) | Chevelle (2) | This Type Of Thinking (Could Do Us In) | Epic | CD, Album | NaN | 2004 | 2751295.0 | CD | 7/14/15 8:39 | NaN | NaN | NaN | 10.00 | NaN | 1.59 | 2.29 | 2.99 | Rock | Alternative Rock | Epic | None | None | None |
Rename columns
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Rating | Released | release_id | CollectionFolder | Date Added | Collection Media Condition | Collection Sleeve Condition | Collection Notes | Collection Cost | Collection Autographed | Min | Median | Max | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 33 | SD 8283 | Yes | Yes | The Yes Album | Atlantic | LP, Album, RE, PR; | NaN | 1971 | 7116823.0 | Vinyl | 7/21/19 20:21 | NaN | NaN | NaN | 5.5 | NaN | 2.25 | 3.87 | 10.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | NaN | 2017 | 8863478.0 | Vinyl | 12/3/16 11:44 | NaN | NaN | NaN | 15.0 | NaN | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal | Relapse Records | None | None | None |
| 2 | 373 | CS 8192 | The Dave Brubeck Quartet | The Dave Brubeck Quartet | Time Out | Columbia | LP, Album | NaN | 1961 | 2676016.0 | Vinyl | 5/5/14 21:16 | NaN | NaN | NaN | 20.0 | NaN | 5.07 | 26.50 | 130.00 | Jazz | Jazz | Columbia | None | None | None |
| 3 | 142 | SD 3-100 | Yes | Yes | Yessongs | Atlantic | 3xLP, Album | 5.0 | 1973 | 8179158.0 | Vinyl | 4/20/17 19:05 | NaN | NaN | NaN | 5.0 | NaN | 3.95 | 9.99 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None |
| 4 | 18 | SD 2-908 | Yes | Yes | Tales From Topographic Oceans | Atlantic | 2xLP, Album, Gat | NaN | 1973 | 8535940.0 | Vinyl | 2/22/20 15:50 | NaN | NaN | NaN | 5.5 | NaN | 7.99 | 13.49 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None |
Export for inspection
Label must be sorted. There is an issue like this where Svart Records is placed before 20 Buck Spin
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Rating | Released | release_id | CollectionFolder | Date Added | Collection Media Condition | Collection Sleeve Condition | Collection Notes | Collection Cost | Collection Autographed | Min | Median | Max | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154 | 88 | SPIN065 | Mournful Congregation | Mournful Congregation | Concrescence Of The Sophia | 20 Buck Spin | LP, MiniAlbum | NaN | 2014 | 5807031.0 | Vinyl | 6/3/18 15:21 | NaN | NaN | NaN | 17.0 | NaN | 6.00 | 9.00 | 15.99 | Metal | Doom Metal | 20 Buck Spin | None | None | None |
| 215 | 156 | SPIN075 | Khemmis | Khemmis | Absolution | 20 Buck Spin | LP, Album, RP | NaN | 2015 | 8551023.0 | Vinyl | 1/18/17 15:05 | NaN | NaN | NaN | 18.0 | Yes | 10.00 | 19.49 | 24.99 | Metal | Doom Metal | 20 Buck Spin | None | None | None |
| 239 | 213 | SPIN048 | Pallbearer | Pallbearer | Sorrow And Extinction | 20 Buck Spin | 2xLP, Album, RP, Blu | 4.0 | 2015 | 6825240.0 | Vinyl | 2/26/16 11:05 | NaN | NaN | NaN | 15.0 | NaN | 20.00 | 29.43 | 36.30 | Metal | Doom Metal | 20 Buck Spin | None | None | None |
| 259 | 157 | SPIN076 | Khemmis | Khemmis | Hunted | 20 Buck Spin | LP, Album | NaN | 2016 | 9222656.0 | Vinyl | 1/18/17 15:05 | NaN | NaN | NaN | 18.0 | Yes | 10.00 | 15.00 | 23.33 | Metal | Doom Metal | 20 Buck Spin | None | None | None |
| 283 | 14 | SVART003, SPIN 080 | Oranssi Pazuzu | Oranssi Pazuzu | V√§r√§htelij√§ | Svart Records, 20 Buck Spin | 2xLP, Ltd, Blu | NaN | 2016 | 11636087.0 | Vinyl | 2/22/20 15:59 | NaN | NaN | NaN | 25.0 | NaN | 20.00 | 24.17 | 26.37 | Metal | Black Metal | Svart Records | 20 Buck Spin | None | None |
| 285 | 133 | SPIN072 | Obsequiae | Obsequiae | Aria Of Vernal Tombs | 20 Buck Spin | LP, Album, Cle | NaN | 2016 | 8556349.0 | Vinyl | 4/27/17 18:58 | NaN | NaN | NaN | 15.0 | NaN | 20.78 | 28.50 | 36.66 | Metal | Black Metal | 20 Buck Spin | None | None | None |
| 311 | 91 | SPIN091 | Acephalix | Acephalix | Decreation | 20 Buck Spin | LP, Album | NaN | 2017 | 10946608.0 | Vinyl | 5/29/18 18:20 | NaN | NaN | NaN | 15.0 | NaN | 11.90 | 18.50 | 27.47 | Metal | Death Metal | 20 Buck Spin | None | None | None |
| 322 | 71 | SVR226, SPIN059 | Oranssi Pazuzu | Oranssi Pazuzu | Valonielu | Svart Records, 20 Buck Spin | LP, Album, RE | NaN | 2017 | 10341101.0 | Vinyl | 12/18/18 14:36 | NaN | NaN | NaN | 15.0 | NaN | 18.71 | 22.06 | 26.56 | Metal | Black Metal | Svart Records | 20 Buck Spin | None | None |
| 346 | 73 | SPIN093 | Spirit Adrift | Spirit Adrift | Curse Of Conception | 20 Buck Spin | LP, Album, Oli | NaN | 2018 | 12305606.0 | Vinyl | 12/18/18 12:39 | NaN | NaN | NaN | 15.0 | NaN | 12.00 | 21.00 | 23.99 | Metal | Doom Metal | 20 Buck Spin | None | None | None |
| 350 | 79 | SPIN081, OPLP338 | Mournful Congregation | Mournful Congregation | The Incubus Of Karma | 20 Buck Spin, Osmose Productions | 2xLP, Album, Ltd | 5.0 | 2018 | 11750808.0 | Vinyl | 8/4/18 8:30 | NaN | NaN | NaN | 27.0 | Yes | 14.00 | 20.32 | 23.91 | Metal | Doom Metal | 20 Buck Spin | Osmose Productions | None | None |
| 355 | 53 | SPIN045, OPLP264 | Mournful Congregation | Mournful Congregation | The Book Of Kings | 20 Buck Spin, Osmose Productions | 2xLP, Album, RP | NaN | 2018 | 13018313.0 | Vinyl | 5/27/19 12:39 | NaN | NaN | NaN | 16.0 | NaN | 15.00 | 19.75 | 26.30 | Metal | Doom Metal | 20 Buck Spin | Osmose Productions | None | None |
| 369 | 74 | SPIN101LP | Tomb Mold | Tomb Mold | Manor Of Infinite Forms | 20 Buck Spin | LP, Album, Ltd, Ora | NaN | 2018 | 12090041.0 | Vinyl | 8/16/18 12:47 | NaN | NaN | NaN | 15.0 | NaN | 23.40 | 35.00 | 50.00 | Metal | Death Metal | 20 Buck Spin | None | None | None |
| 388 | 36 | SPIN112 | Immortal Bird | Immortal Bird | Thrive On Neglect | 20 Buck Spin | LP, Album, Ltd | NaN | 2019 | 13835380.0 | Vinyl | 7/21/19 20:18 | NaN | NaN | NaN | 21.0 | Yes | 19.98 | 24.49 | 29.00 | Metal | Black Metal | 20 Buck Spin | None | None | None |
| 402 | 10 | SPIN114 | Tomb Mold | Tomb Mold | Planetary Clairvoyance | 20 Buck Spin | LP, Album, Ltd, Sil | NaN | 2019 | 13909660.0 | Vinyl | 2/22/20 16:07 | NaN | NaN | NaN | 20.0 | Yes | NaN | NaN | NaN | Metal | Death Metal | 20 Buck Spin | None | None | None |
283 Svart Records, 20 Buck Spin 322 Svart Records, 20 Buck Spin 393 Roadburn Records Name: Label, dtype: object
['Svart Records', '20 Buck Spin']
Sort like this
['20 Buck Spin', 'Svart Records']
Drop column
| Artist | Label | Record | |
|---|---|---|---|
| 0 | Yes | Atlantic | Yes - The Yes Album |
| 1 | Mastodon | Relapse Records | Mastodon - Remission |
| 2 | The Dave Brubeck Quartet | Columbia | The Dave Brubeck Quartet - Time Out |
| 3 | Yes | Atlantic | Yes - Yessongs |
| 4 | Yes | Atlantic | Yes - Tales From Topographic Oceans |
Run Pandas Profiler
Here are some interesting information about my record collection:
1) I purchased around 408 albums in vinyl, CD, and tape format.
2) I have 188 unique artists in my collection. I also have 10 artists that collaborated with others.
3) My top five bands are:
| Artist2 | Count | Percentage |
|---|---|---|
| Opeth | 19 | 4.7% |
| Cult Of Luna | 16 | 3.9% |
| Isis (6) | 12 | 2.9% |
| Panopticon (6) | 11 | 2.7% |
| Between The Buried And Me | 10 | 2.5% |
4) I own 388 distinct albums.
5) In my collection, 84.3% are vinyl and 15.4\% are CD. I have 2 Tapes.
6) My top 5 genres are:
| Genre | Count | Percentage |
|---|---|---|
| Metal | 358 | 87.7% |
| Rock | 31 | 7.6% |
| Electronic | 12 | 2.9% |
| Pop | 3 | 0.7% |
| Hip Hop | 2 | 0.5% |
7) My top 5 subgenres are:
| Genre | Count | Percentage |
|---|---|---|
| Black Metal | 83 | 20.3% |
| Progressive Metal | 62 | 15.2% |
| Post Metal | 61 | 15.0% |
| Djent | 26 | 6.4% |
| Sludge Metal | 26 | 6.4% |
7) I typically pay \$15 (50 or 12.3\%) for a record. The next is \\$20 (49 or 12.0\%).
8) The most frequent album sold at the _Max_ price is \$29.99 (12 or 2.9\%). Next is \\$39.99 (9 or 2.2\%).
9) My top five record labels are:
| Label | Count | Percentage |
|---|---|---|
| Relapse Records | 23 | 5.6% |
| Century Media | 17 | 4.2% |
| Prosthetic Records | 13 | 3.2% |
| Hydra Head Records | 12 | 2.9% |
| 20 Buck Spin | 10 | 2.5% |
10) Most albums I buy were released in the last several years:
| Year | Count | Percentage |
|---|---|---|
| 2014 | 61 | 15.0% |
| 2013 | 55 | 13.5% |
| 2016 | 52 | 12.7% |
| 2015 | 48 | 11.8% |
| 2017 | 40 | 9.8% |
Get summary statistics
| ID | Released | release_id | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| count | 408.000000 | 408.000000 | 4.070000e+02 | 408.000000 | 392.000000 | 392.000000 | 392.000000 |
| mean | 204.504902 | 2013.164216 | 7.330329e+06 | 18.528627 | 17.322449 | 25.659311 | 38.255561 |
| std | 117.932184 | 7.567225 | 3.417850e+06 | 14.222461 | 22.008193 | 29.396237 | 47.702644 |
| min | 1.000000 | 1961.000000 | 3.764730e+05 | 0.000000 | 0.860000 | 2.250000 | 2.990000 |
| 25% | 102.750000 | 2013.000000 | 4.823426e+06 | 12.000000 | 8.000000 | 14.037500 | 20.000000 |
| 50% | 204.500000 | 2015.000000 | 6.820328e+06 | 17.000000 | 14.980000 | 21.990000 | 29.260000 |
| 75% | 306.250000 | 2017.000000 | 9.817652e+06 | 23.000000 | 21.210000 | 29.862500 | 40.000000 |
| max | 409.000000 | 2020.000000 | 1.473373e+07 | 232.000000 | 389.000000 | 514.170000 | 799.990000 |
Run correlation
<matplotlib.axes._subplots.AxesSubplot at 0x1273eb610>
<matplotlib.axes._subplots.AxesSubplot at 0x12d48fbd0>
Remove outlier
<matplotlib.axes._subplots.AxesSubplot at 0x12d493210>
<matplotlib.axes._subplots.AxesSubplot at 0x12d2c4890>
| index | 0 | |
|---|---|---|
| 0 | Collection_Cost | 7559.68 |
| 1 | _Min_ | 6790.40 |
| 2 | _Median_ | 10058.45 |
| 3 | _Max_ | 14996.18 |
I spent $ 7559.679999999999 on music that is recorded on Discogs. My collection is worth $ 10058.45
| index | 0 | |
|---|---|---|
| 0 | Collection_Cost | 18.528627 |
| 1 | _Min_ | 17.322449 |
| 2 | _Median_ | 25.659311 |
| 3 | _Max_ | 38.255561 |
I spent on averege $ 18.53 on per album that is recorded on Discogs. My average collection is worth $ 25.66
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Released | release_id | CollectionFolder | Date_Added | Collection_Cost | Collection_Autographed | _Min_ | _Median_ | _Max_ | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | Record | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 302 | 187 | NB 3446-5, 3446-5 | Meshuggah | Meshuggah | 25 Years Of Musical Deviance | Nuclear Blast, Nuclear Blast | Box, Comp, Ltd + 12", EP, RE, Cle + 2xLP, Albu... | 2016 | 8808750.0 | Vinyl | 7/28/16 20:17 | 232.0 | No | 389.0 | 514.17 | 799.99 | Metal | Djent | Nuclear Blast | Nuclear Blast | None | None | Meshuggah - 25 Years Of Musical Deviance |
| Artist | Title | Format | Collection_Cost | _Median_ | Genre | Subgenre | |
|---|---|---|---|---|---|---|---|
| 302 | Meshuggah | 25 Years Of Musical Deviance | Box, Comp, Ltd + 12", EP, RE, Cle + 2xLP, Albu... | 232.0 | 514.17 | Metal | Djent |
This record has 7 full length albums and 3 EPs plus a DVD and a lyric book
The most expensive record I own is the Meshuggah - 25 Years Of Musical Deviance, Boxset.
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Released | release_id | CollectionFolder | Date_Added | Collection_Cost | Collection_Autographed | _Min_ | _Median_ | _Max_ | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | Record | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 189 | Relic 009 | Bunrage / Footpaths | Bunrage / Footpaths | Untitled | Haute Magie | LP, Cle | 2012 | 3469073.0 | Vinyl | 6/18/16 13:22 | 0.0 | No | NaN | NaN | NaN | Folk | Folk | Haute Magie | None | None | None | Bunrage / Footpaths - Untitled |
| Artist | Title | Format | Collection_Cost | _Median_ | Genre | Subgenre | |
|---|---|---|---|---|---|---|---|
| 87 | Bunrage / Footpaths | Untitled | LP, Cle | 0.0 | NaN | Folk | Folk |
I got this record for free from a friend
| Artist | Title | Format | Collection_Cost | _Median_ | Genre | Subgenre | |
|---|---|---|---|---|---|---|---|
| 13 | Whitesnake | Whitesnake | LP, Album | 0.5 | 9.05 | Rock | Classic Rock |
| 17 | Wyclef Jean | The Preacher's Son | 2xLP, Promo | 0.5 | 3.88 | Hip Hop | Hip Hop |
I bought Wyclef Jean 2xLP at the basement of Dusty Groove for 50 cents.
| CollectionFolder | Record | Genre | Subgenre | Collection_Autographed | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|---|
| 302 | Vinyl | Meshuggah - 25 Years Of Musical Deviance | Metal | Djent | No | 232.0 | 389.00 | 514.17 | 799.99 |
| 54 | Vinyl | Opeth - In Live Concert At The Royal Albert Hall | Metal | Progressive Metal | No | 66.0 | 85.99 | 117.83 | 141.76 |
| 394 | Vinyl | Cult Of Luna - A Dawn To Fear | Metal | Post Metal | No | 66.0 | 27.47 | 54.74 | 58.23 |
| 201 | Vinyl | Mastodon - Remission | Metal | Sludge Metal | No | 55.0 | 45.00 | 81.97 | 143.90 |
| 254 | Vinyl | Opeth - Book Of Opeth | Metal | Progressive Metal | No | 50.0 | 6.57 | 59.28 | 97.80 |
| 288 | Vinyl | Cult Of Luna - Salvation | Metal | Post Metal | No | 45.0 | 24.00 | 51.12 | 56.18 |
| 294 | Vinyl | Cult Of Luna - Somewhere Along The Highway | Metal | Post Metal | No | 45.0 | 28.00 | 59.20 | 79.99 |
| 303 | Vinyl | Sioum - Yet Further | Metal | Progressive Metal | No | 40.0 | NaN | NaN | NaN |
| 122 | Vinyl | Opeth - Ghost Reveries | Metal | Progressive Metal | No | 40.0 | 20.00 | 24.98 | 32.18 |
| 202 | Vinyl | Leprous - Bilateral | Metal | Progressive Metal | Yes | 40.0 | 50.00 | 111.52 | 155.02 |
| CollectionFolder | Record | Genre | Subgenre | Collection_Autographed | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|---|
| 302 | Vinyl | Meshuggah - 25 Years Of Musical Deviance | Metal | Djent | No | 232.0 | 389.00 | 514.17 | 799.99 |
| 54 | Vinyl | Opeth - In Live Concert At The Royal Albert Hall | Metal | Progressive Metal | No | 66.0 | 85.99 | 117.83 | 141.76 |
| 394 | Vinyl | Cult Of Luna - A Dawn To Fear | Metal | Post Metal | No | 66.0 | 27.47 | 54.74 | 58.23 |
| 201 | Vinyl | Mastodon - Remission | Metal | Sludge Metal | No | 55.0 | 45.00 | 81.97 | 143.90 |
| 254 | Vinyl | Opeth - Book Of Opeth | Metal | Progressive Metal | No | 50.0 | 6.57 | 59.28 | 97.80 |
| 288 | Vinyl | Cult Of Luna - Salvation | Metal | Post Metal | No | 45.0 | 24.00 | 51.12 | 56.18 |
| 294 | Vinyl | Cult Of Luna - Somewhere Along The Highway | Metal | Post Metal | No | 45.0 | 28.00 | 59.20 | 79.99 |
| 303 | Vinyl | Sioum - Yet Further | Metal | Progressive Metal | No | 40.0 | NaN | NaN | NaN |
| 122 | Vinyl | Opeth - Ghost Reveries | Metal | Progressive Metal | No | 40.0 | 20.00 | 24.98 | 32.18 |
| 202 | Vinyl | Leprous - Bilateral | Metal | Progressive Metal | Yes | 40.0 | 50.00 | 111.52 | 155.02 |
| 310 | CD | Cult Of Luna - Years In A Day | Metal | Post Metal | No | 40.0 | 11.65 | 20.50 | 32.99 |
| 168 | CD | Skyharbor - Guiding Lights | Metal | Djent | Yes | 30.0 | 10.00 | 11.83 | 14.86 |
| 107 | CD | Tesseract - Altered State | Metal | Djent | No | 17.0 | 13.00 | 32.00 | 39.99 |
| 88 | CD | Scale The Summit - The Migration | Metal | Progressive Metal | No | 15.0 | 2.00 | 7.07 | 11.54 |
| 18 | CD | Kayo Dot - Choirs Of The Eye | Metal | Progressive Metal | Yes | 15.0 | 6.66 | 10.19 | 16.37 |
| 151 | CD | Cynic (2) - Kindly Bent To Free Us | Metal | Progressive Metal | No | 14.0 | 5.33 | 7.38 | 17.17 |
| 30 | CD | Cynic (2) - Traced In Air | Metal | Progressive Metal | No | 14.0 | 6.00 | 9.63 | 14.43 |
| 61 | CD | Cynic (2) - Carbon-Based Anatomy | Metal | Progressive Metal | No | 12.0 | 4.95 | 7.00 | 9.81 |
| 94 | CD | The Ocean (2) - Pelagial | Metal | Post Metal | No | 12.0 | 7.69 | 12.50 | 14.99 |
| 58 | CD | TesseracT - One | Metal | Djent | No | 11.0 | 3.00 | 11.00 | 16.99 |
| 398 | Tape | Krallice - Rot And Waste Live | Metal | Black Metal | No | 10.0 | NaN | NaN | NaN |
| Artist2 | Title | Label | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 35 | Cult Of Luna | 16 | 7 | 552.75 | 390.58 | 576.84 | 795.90 |
| 105 | Opeth | 19 | 13 | 533.00 | 419.55 | 660.02 | 1013.97 |
| 88 | Meshuggah | 2 | 1 | 260.00 | 403.00 | 546.67 | 839.98 |
| 111 | Panopticon (6) | 11 | 4 | 238.25 | 205.87 | 285.85 | 406.34 |
| 73 | Isis (6) | 12 | 4 | 217.00 | 214.61 | 317.39 | 492.03 |
| 38 | Deathspell Omega | 9 | 3 | 190.00 | 152.34 | 215.67 | 355.69 |
| 87 | Mastodon | 9 | 5 | 177.00 | 124.95 | 236.89 | 409.37 |
| 15 | Between The Buried And Me | 10 | 2 | 157.50 | 234.89 | 333.08 | 544.67 |
| 155 | Thou (2) | 9 | 9 | 137.00 | 123.96 | 180.03 | 246.03 |
| 112 | Perturbator | 5 | 2 | 130.00 | 116.89 | 178.00 | 261.04 |
| Artist2 | Title | Label | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 105 | Opeth | 19 | 13 | 533.00 | 419.55 | 660.02 | 1013.97 |
| 35 | Cult Of Luna | 16 | 7 | 552.75 | 390.58 | 576.84 | 795.90 |
| 73 | Isis (6) | 12 | 4 | 217.00 | 214.61 | 317.39 | 492.03 |
| 111 | Panopticon (6) | 11 | 4 | 238.25 | 205.87 | 285.85 | 406.34 |
| 15 | Between The Buried And Me | 10 | 2 | 157.50 | 234.89 | 333.08 | 544.67 |
| 87 | Mastodon | 9 | 5 | 177.00 | 124.95 | 236.89 | 409.37 |
| 38 | Deathspell Omega | 9 | 3 | 190.00 | 152.34 | 215.67 | 355.69 |
| 155 | Thou (2) | 9 | 9 | 137.00 | 123.96 | 180.03 | 246.03 |
| 80 | Krallice | 6 | 2 | 126.00 | 93.87 | 135.20 | 143.58 |
| 186 | Yes | 6 | 1 | 28.00 | 21.82 | 46.15 | 105.74 |
| Record | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|
| 302 | Meshuggah - 25 Years Of Musical Deviance | 232.0 | 389.00 | 514.17 | 799.99 |
| 54 | Opeth - In Live Concert At The Royal Albert Hall | 66.0 | 85.99 | 117.83 | 141.76 |
| 142 | Haken (2) - The Mountain | 22.0 | 64.84 | 81.20 | 109.88 |
| 86 | Between The Buried And Me - The Parallax II: F... | 30.0 | 60.00 | 70.00 | 113.64 |
| 341 | Yellow Eyes (2) - Immersion Trench Reverie | 15.0 | 60.00 | 69.50 | 79.00 |
| 340 | Isis (6) - Live VII - 02.25.10 | 18.0 | 60.00 | 65.96 | 90.00 |
| 141 | Opeth - Heritage | 40.0 | 54.95 | 75.92 | 100.00 |
| 140 | Between The Buried And Me - The Anatomy Of | 21.0 | 54.95 | 78.50 | 165.00 |
| 139 | Leprous - Coal | 20.0 | 54.93 | 59.44 | 87.91 |
| 202 | Leprous - Bilateral | 40.0 | 50.00 | 111.52 | 155.02 |
| Record | Title | Subgenre | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 302 | Meshuggah - 25 Years Of Musical Deviance | 25 Years Of Musical Deviance | Djent | 232.0 | 389.00 | 514.17 | 799.99 |
| 54 | Opeth - In Live Concert At The Royal Albert Hall | In Live Concert At The Royal Albert Hall | Progressive Metal | 66.0 | 85.99 | 117.83 | 141.76 |
| 202 | Leprous - Bilateral | Bilateral | Progressive Metal | 40.0 | 50.00 | 111.52 | 155.02 |
| 201 | Mastodon - Remission | Remission | Sludge Metal | 55.0 | 45.00 | 81.97 | 143.90 |
| 142 | Haken (2) - The Mountain | The Mountain | Progressive Metal | 22.0 | 64.84 | 81.20 | 109.88 |
| 140 | Between The Buried And Me - The Anatomy Of | The Anatomy Of | Progressive Metal | 21.0 | 54.95 | 78.50 | 165.00 |
| 203 | Ne Obliviscaris - Portal Of I | Portal Of I | Progressive Metal | 30.0 | 50.00 | 77.81 | 250.00 |
| 141 | Opeth - Heritage | Heritage | Progressive Metal | 40.0 | 54.95 | 75.92 | 100.00 |
| 86 | Between The Buried And Me - The Parallax II: F... | The Parallax II: Future Sequence | Progressive Metal | 30.0 | 60.00 | 70.00 | 113.64 |
| 341 | Yellow Eyes (2) - Immersion Trench Reverie | Immersion Trench Reverie | Black Metal | 15.0 | 60.00 | 69.50 | 79.00 |
| Record | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|
| 302 | Meshuggah - 25 Years Of Musical Deviance | 232.0 | 389.00 | 514.17 | 799.99 |
| 203 | Ne Obliviscaris - Portal Of I | 30.0 | 50.00 | 77.81 | 250.00 |
| 81 | Gorod - A Perfect Absolution | 12.0 | 19.99 | 48.05 | 199.98 |
| 140 | Between The Buried And Me - The Anatomy Of | 21.0 | 54.95 | 78.50 | 165.00 |
| 202 | Leprous - Bilateral | 40.0 | 50.00 | 111.52 | 155.02 |
| 201 | Mastodon - Remission | 55.0 | 45.00 | 81.97 | 143.90 |
| 54 | Opeth - In Live Concert At The Royal Albert Hall | 66.0 | 85.99 | 117.83 | 141.76 |
| 2 | The Dave Brubeck Quartet - Time Out | 20.0 | 5.07 | 26.50 | 130.00 |
| 248 | Opeth - Deliverance & Damnation | 36.0 | 33.03 | 58.44 | 119.99 |
| 194 | Opeth - Watershed | 30.0 | 25.00 | 55.00 | 119.00 |
The Meshuggah boxset was sold for 514.17 and I bought it for 232.
| Artist2 | Title | Label | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 88 | Meshuggah | 2 | 1 | 130.000000 | 201.500000 | 273.335000 | 419.990000 |
| 83 | Leprous | 3 | 2 | 28.000000 | 42.586667 | 67.493333 | 95.106667 |
| 96 | Ne Obliviscaris | 2 | 2 | 25.000000 | 37.000000 | 54.520000 | 144.230000 |
| 150 | The Contortionist (2) | 4 | 3 | 20.625000 | 30.247500 | 54.057500 | 68.232500 |
| 3 | Altar Of Plagues | 1 | 1 | 36.500000 | 40.000000 | 49.990000 | 82.050000 |
| 56 | Gojira (2) | 1 | 1 | 30.000000 | 33.000000 | 48.490000 | 65.000000 |
| 185 | Yellow Eyes (2) | 2 | 1 | 16.500000 | 41.995000 | 47.075000 | 52.495000 |
| 31 | Cloudkicker | 1 | 1 | 15.000000 | 30.000000 | 46.980000 | 55.000000 |
| 171 | Vildhjarta | 2 | 2 | 17.500000 | 25.495000 | 46.385000 | 59.990000 |
| 12 | Baroness | 3 | 2 | 17.543333 | 29.680000 | 45.973333 | 66.583333 |
| Artist2 | Title | Label | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 88 | Meshuggah | 2 | 1 | 130.000 | 201.500000 | 273.335000 | 419.990000 |
| 96 | Ne Obliviscaris | 2 | 2 | 25.000 | 37.000000 | 54.520000 | 144.230000 |
| 151 | The Dave Brubeck Quartet | 1 | 1 | 20.000 | 5.070000 | 26.500000 | 130.000000 |
| 58 | Gorod | 2 | 1 | 14.000 | 15.995000 | 35.275000 | 114.990000 |
| 83 | Leprous | 3 | 2 | 28.000 | 42.586667 | 67.493333 | 95.106667 |
| 3 | Altar Of Plagues | 1 | 1 | 36.500 | 40.000000 | 49.990000 | 82.050000 |
| 1 | Agalloch | 1 | 1 | 30.000 | 16.000000 | 35.000000 | 70.650000 |
| 41 | Devourment | 1 | 1 | 13.630 | 20.000000 | 31.000000 | 69.990000 |
| 23 | Carpenter Brut | 1 | 1 | 36.000 | 32.610000 | 35.850000 | 69.980000 |
| 150 | The Contortionist (2) | 4 | 3 | 20.625 | 30.247500 | 54.057500 | 68.232500 |
| Artist2 | Title | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|
| 54 | Opeth | In Live Concert At The Royal Albert Hall | 66.0 | 85.99 | 117.83 | 141.76 |
| 248 | Opeth | Deliverance & Damnation | 36.0 | 33.03 | 58.44 | 119.99 |
| 194 | Opeth | Watershed | 30.0 | 25.00 | 55.00 | 119.00 |
| 141 | Opeth | Heritage | 40.0 | 54.95 | 75.92 | 100.00 |
| 254 | Opeth | Book Of Opeth | 50.0 | 6.57 | 59.28 | 97.80 |
| 131 | Opeth | Morningrise | 6.0 | 26.00 | 35.00 | 65.21 |
| 32 | Opeth | Orchid | 22.0 | 19.47 | 32.61 | 43.48 |
| 238 | Opeth | The Roundhouse Tapes | 30.0 | 20.00 | 26.26 | 42.50 |
| 33 | Opeth | My Arms, Your Hearse | 6.0 | 20.00 | 33.33 | 41.11 |
| 273 | Opeth | Lamentations Live At Shepherd's Bush Empire | 30.0 | 15.05 | 28.05 | 39.98 |
| 52 | Opeth | Blackwater Park | 31.0 | 26.19 | 31.99 | 39.98 |
| 187 | Opeth | Pale Communion | 29.0 | 18.89 | 20.55 | 33.32 |
| 122 | Opeth | Ghost Reveries | 40.0 | 20.00 | 24.98 | 32.18 |
| 277 | Opeth | Sorceress | 20.0 | 18.67 | 24.00 | 31.00 |
| 82 | Opeth | Still Life | 32.0 | 20.31 | 21.18 | 30.99 |
| 21 | Opeth | Lamentations - Live At Shepherd's Bush Empire ... | 6.0 | 4.99 | 6.40 | 19.00 |
| 48 | Opeth | The Roundhouse Tapes | 9.0 | 4.44 | 9.20 | 16.67 |
| 399 | Opeth | In Cauda Venenum | 25.0 | NaN | NaN | NaN |
| 400 | Opeth | In Cauda Venenum | 25.0 | NaN | NaN | NaN |
| Label | Artist2 | Title | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 113 | Relapse Records | 13 | 23 | 451.27 | 374.98 | 591.73 | 943.35 |
| 104 | Nuclear Blast, Nuclear Blast | 3 | 4 | 289.50 | 427.74 | 579.53 | 885.80 |
| 23 | Century Media | 10 | 17 | 346.00 | 275.26 | 458.06 | 650.54 |
| 17 | Blood Music (2) | 5 | 9 | 260.00 | 268.74 | 429.77 | 748.10 |
| 109 | Prosthetic Records | 6 | 13 | 221.00 | 164.36 | 271.41 | 391.61 |
| Label | Artist2 | Title | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|
| 113 | Relapse Records | 13 | 23 | 451.27 | 374.98 | 591.73 | 943.35 |
| 23 | Century Media | 10 | 17 | 346.00 | 275.26 | 458.06 | 650.54 |
| 104 | Nuclear Blast, Nuclear Blast | 3 | 4 | 289.50 | 427.74 | 579.53 | 885.80 |
| 17 | Blood Music (2) | 5 | 9 | 260.00 | 268.74 | 429.77 | 748.10 |
| 41 | Earache | 4 | 9 | 230.74 | 160.17 | 260.32 | 319.41 |
| 109 | Prosthetic Records | 6 | 13 | 221.00 | 164.36 | 271.41 | 391.61 |
| 66 | Indie Recordings | 1 | 5 | 175.00 | 124.12 | 170.59 | 269.45 |
| 52 | Gilead Media | 4 | 9 | 172.50 | 200.85 | 260.41 | 300.35 |
| 1 | 20 Buck Spin | 8 | 10 | 169.00 | 134.06 | 200.41 | 267.73 |
| 91 | Nordvis Produktion, Bindrune Recordings | 3 | 7 | 164.00 | 170.63 | 214.93 | 296.49 |
Index(['ID', 'Catalog#', 'Artist', 'Artist2', 'Title', 'Label', 'Format',
'Released', 'release_id', 'CollectionFolder', 'Date_Added',
'Collection_Cost', 'Collection_Autographed', '_Min_', '_Median_',
'_Max_', 'Genre', 'Subgenre', 'Label1', 'Label2', 'Label3', 'Label4',
'Record'],
dtype='object')
0 07/2019 1 12/2016 2 05/2014 3 04/2017 4 02/2020 Name: Date_Added, dtype: object
Released and Date_Added then get sum by Collection_Cost, _Min_, _Median_, and _Max_.¶| Released | Date_Added | Collection_Cost | Artist | Artist2 | Title | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|---|
| 60 | 2012 | 01/2014 | 12.00 | 1 | 1 | 1 | 4.66 | 12.05 | 19.69 |
| 73 | 2013 | 01/2014 | 68.00 | 4 | 4 | 5 | 106.05 | 161.86 | 223.85 |
| 48 | 2011 | 01/2014 | 8.00 | 1 | 1 | 1 | 8.86 | 11.09 | 15.38 |
| 92 | 2014 | 01/2015 | 52.00 | 2 | 2 | 2 | 28.50 | 72.73 | 95.91 |
| 127 | 2016 | 01/2016 | 20.72 | 1 | 1 | 1 | 16.56 | 23.66 | 33.00 |
Plot Date_Added over Collection_Cost
Plot Date_Added over Title
Plot Date_Added over Artist2
There were some days that I logged many records at once on discogs.
Released¶| Released | Artist2 | Title | CollectionFolder | Genre | Subgenre | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1961 | 1 | 1 | 1 | 1 | 1 | 20.0 | 5.07 | 26.50 | 130.00 |
| 1 | 1971 | 1 | 1 | 1 | 1 | 1 | 5.5 | 2.25 | 3.87 | 10.00 |
| 2 | 1973 | 2 | 2 | 2 | 2 | 2 | 10.5 | 11.94 | 23.48 | 40.00 |
| 3 | 1974 | 1 | 1 | 1 | 1 | 1 | 4.0 | 1.13 | 7.00 | 30.74 |
| 4 | 1975 | 1 | 1 | 1 | 1 | 1 | 12.0 | 10.00 | 17.00 | 25.00 |
count 32.0000 mean 1998.2500 std 17.5683 min 1961.0000 25% 1979.7500 50% 2004.5000 75% 2012.2500 max 2020.0000 Name: Released, dtype: float64
<seaborn.axisgrid.FacetGrid at 0x12ee73610>
<seaborn.axisgrid.FacetGrid at 0x12ce6bfd0>
<seaborn.axisgrid.FacetGrid at 0x12cd35c90>
<seaborn.axisgrid.FacetGrid at 0x12de77b90>
<seaborn.axisgrid.FacetGrid at 0x12cdbf150>
Metal 358 Rock 31 Electronic 12 Pop 3 Hip Hop 2 Jazz 1 Folk 1 Name: Genre, dtype: int64
Remove records less than 2
['Metal', 'Rock', 'Electronic', 'Pop']
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Released | release_id | CollectionFolder | Date_Added | Collection_Cost | Collection_Autographed | _Min_ | _Median_ | _Max_ | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | Record | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 33 | SD 8283 | Yes | Yes | The Yes Album | Atlantic | LP, Album, RE, PR; | 1971 | 7116823.0 | Vinyl | 07/2019 | 5.5 | No | 2.25 | 3.87 | 10.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - The Yes Album |
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | 2017 | 8863478.0 | Vinyl | 12/2016 | 15.0 | No | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal | Relapse Records | None | None | None | Mastodon - Remission |
| 3 | 142 | SD 3-100 | Yes | Yes | Yessongs | Atlantic | 3xLP, Album | 1973 | 8179158.0 | Vinyl | 04/2017 | 5.0 | No | 3.95 | 9.99 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Yessongs |
| 4 | 18 | SD 2-908 | Yes | Yes | Tales From Topographic Oceans | Atlantic | 2xLP, Album, Gat | 1973 | 8535940.0 | Vinyl | 02/2020 | 5.5 | No | 7.99 | 13.49 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Tales From Topographic Oceans |
| 5 | 340 | SD 18122 | Yes | Yes | Relayer | Atlantic | LP, Album, Gat | 1974 | 755646.0 | Vinyl | 09/2014 | 4.0 | No | 1.13 | 7.00 | 30.74 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Relayer |
Metal 357 Rock 31 Electronic 12 Pop 3 Name: Genre, dtype: int64
Black Metal 83 Progressive Metal 62 Post Metal 61 Djent 26 Sludge Metal 26 Death Metal 21 Doom Metal 17 Grindcore 16 Technical Death Metal 15 Hardcore 13 Outrun 9 Progressive Rock 7 Heavy Metal 7 Alternative Rock 6 Thrash Metal 5 Grunge 3 Synthpop 3 Folk 3 Classic Rock 3 Shoegaze 2 Post Hardcore 2 Hip Hop 2 Stoner Metal 2 Psychdelic 2 Melodic Death Metal 2 Pop 2 Rock 1 Synthwave 1 Metalcore 1 Noise Rock 1 Post Rock 1 Jazz 1 Gothic Metal 1 Name: Subgenre, dtype: int64
['Black Metal', 'Progressive Metal', 'Post Metal', 'Djent', 'Sludge Metal', 'Death Metal', 'Doom Metal', 'Grindcore', 'Technical Death Metal', 'Hardcore', 'Outrun', 'Progressive Rock', 'Heavy Metal', 'Alternative Rock']
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Released | release_id | CollectionFolder | Date_Added | Collection_Cost | Collection_Autographed | _Min_ | _Median_ | _Max_ | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | Record | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 33 | SD 8283 | Yes | Yes | The Yes Album | Atlantic | LP, Album, RE, PR; | 1971 | 7116823.0 | Vinyl | 07/2019 | 5.5 | No | 2.25 | 3.87 | 10.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - The Yes Album |
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | 2017 | 8863478.0 | Vinyl | 12/2016 | 15.0 | No | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal | Relapse Records | None | None | None | Mastodon - Remission |
| 3 | 142 | SD 3-100 | Yes | Yes | Yessongs | Atlantic | 3xLP, Album | 1973 | 8179158.0 | Vinyl | 04/2017 | 5.0 | No | 3.95 | 9.99 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Yessongs |
| 4 | 18 | SD 2-908 | Yes | Yes | Tales From Topographic Oceans | Atlantic | 2xLP, Album, Gat | 1973 | 8535940.0 | Vinyl | 02/2020 | 5.5 | No | 7.99 | 13.49 | 20.00 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Tales From Topographic Oceans |
| 5 | 340 | SD 18122 | Yes | Yes | Relayer | Atlantic | LP, Album, Gat | 1974 | 755646.0 | Vinyl | 09/2014 | 4.0 | No | 1.13 | 7.00 | 30.74 | Rock | Progressive Rock | Atlantic | None | None | None | Yes - Relayer |
[Text(0, 0, 'Progressive Rock'), Text(0, 0, 'Sludge Metal'), Text(0, 0, 'Heavy Metal'), Text(0, 0, 'Progressive Metal'), Text(0, 0, 'Hardcore'), Text(0, 0, 'Post Metal'), Text(0, 0, 'Alternative Rock'), Text(0, 0, 'Grindcore'), Text(0, 0, 'Black Metal'), Text(0, 0, 'Doom Metal'), Text(0, 0, 'Djent'), Text(0, 0, 'Technical Death Metal'), Text(0, 0, 'Death Metal'), Text(0, 0, 'Outrun')]
Reduce to Top 5 subgenres
| ID | Catalog# | Artist | Artist2 | Title | Label | Format | Released | release_id | CollectionFolder | Date_Added | Collection_Cost | Collection_Autographed | _Min_ | _Median_ | _Max_ | Genre | Subgenre | Label1 | Label2 | Label3 | Label4 | Record | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 165 | RR 6583-1 | Mastodon | Mastodon | Remission | Relapse Records | 2x12", Album, RE, RM, RP | 2017 | 8863478.0 | Vinyl | 12/2016 | 15.0 | No | 7.99 | 21.67 | 30.19 | Metal | Sludge Metal | Relapse Records | None | None | None | Mastodon - Remission |
| 14 | 275 | RR 6427-2 | The Dillinger Escape Plan | The Dillinger Escape Plan | Calculating Infinity | Relapse Records | CD, Album | 1999 | 5536513.0 | CD | 06/2015 | 1.0 | No | 0.86 | 5.51 | 11.99 | Metal | Progressive Metal | Relapse Records | None | None | None | The Dillinger Escape Plan - Calculating Infinity |
| 16 | 375 | IPC-32 | Isis (6) | Isis (6) | Oceanic | Ipecac Recordings | CD, Album | 2002 | 376473.0 | CD | 03/2014 | 7.0 | No | 4.58 | 6.33 | 12.97 | Metal | Post Metal | Ipecac Recordings | None | None | None | Isis (6) - Oceanic |
| 18 | 146 | TZ 7092 | Kayo Dot | Kayo Dot | Choirs Of The Eye | Tzadik | CD, Album, Cre | 2003 | 649369.0 | CD | 04/2017 | 15.0 | Yes | 6.66 | 10.19 | 16.37 | Metal | Progressive Metal | Tzadik | None | None | None | Kayo Dot - Choirs Of The Eye |
| 20 | 325 | IPC-57 | Isis (6) | Isis (6) | Panopticon | Ipecac Recordings | CD, Album | 2004 | 377605.0 | CD | 11/2014 | 7.0 | No | 4.55 | 9.91 | 11.99 | Metal | Post Metal | Ipecac Recordings | None | None | None | Isis (6) - Panopticon |
[Text(0, 0, 'Sludge Metal'), Text(0, 0, 'Progressive Metal'), Text(0, 0, 'Post Metal'), Text(0, 0, 'Black Metal'), Text(0, 0, 'Djent')]
| CollectionFolder | Record | Genre | Subgenre | Collection_Autographed | Collection_Cost | _Median_ | |
|---|---|---|---|---|---|---|---|
| 302 | Vinyl | Meshuggah - 25 Years Of Musical Deviance | Metal | Djent | No | 232.0 | 514.17 |
| 54 | Vinyl | Opeth - In Live Concert At The Royal Albert Hall | Metal | Progressive Metal | No | 66.0 | 117.83 |
| 202 | Vinyl | Leprous - Bilateral | Metal | Progressive Metal | Yes | 40.0 | 111.52 |
| 201 | Vinyl | Mastodon - Remission | Metal | Sludge Metal | No | 55.0 | 81.97 |
| 142 | Vinyl | Haken (2) - The Mountain | Metal | Progressive Metal | Yes | 22.0 | 81.20 |
| 140 | Vinyl | Between The Buried And Me - The Anatomy Of | Metal | Progressive Metal | No | 21.0 | 78.50 |
| 203 | Vinyl | Ne Obliviscaris - Portal Of I | Metal | Progressive Metal | Yes | 30.0 | 77.81 |
| 141 | Vinyl | Opeth - Heritage | Metal | Progressive Metal | Yes | 40.0 | 75.92 |
| 86 | Vinyl | Between The Buried And Me - The Parallax II: F... | Metal | Progressive Metal | No | 30.0 | 70.00 |
| 341 | Vinyl | Yellow Eyes (2) - Immersion Trench Reverie | Metal | Black Metal | No | 15.0 | 69.50 |
| 340 | Vinyl | Isis (6) - Live VII - 02.25.10 | Metal | Post Metal | No | 18.0 | 65.96 |
| 186 | Vinyl | The Contortionist (2) - Language | Metal | Djent | Yes | 15.0 | 65.11 |
| 135 | Vinyl | Vildhjarta - Thousands Of Evils | Metal | Djent | No | 18.0 | 62.78 |
| 250 | Vinyl | The Contortionist (2) - Exoplanet | Metal | Djent | No | 25.5 | 60.12 |
| 138 | Vinyl | The Contortionist (2) - Intrinsic | Metal | Djent | No | 15.0 | 60.00 |
| 139 | Vinyl | Leprous - Coal | Metal | Progressive Metal | Yes | 20.0 | 59.44 |
| 254 | Vinyl | Opeth - Book Of Opeth | Metal | Progressive Metal | No | 50.0 | 59.28 |
| 294 | Vinyl | Cult Of Luna - Somewhere Along The Highway | Metal | Post Metal | No | 45.0 | 59.20 |
| 248 | Vinyl | Opeth - Deliverance & Damnation | Metal | Progressive Metal | No | 36.0 | 58.44 |
| 137 | Vinyl | Tesseract - Altered State | Metal | Djent | No | 20.0 | 57.77 |
| 107 | CD | Tesseract - Altered State | Metal | Djent | No | 17.0 | 32.00 |
| 190 | CD | Son Of Aurelius - Under A Western Sun | Metal | Progressive Metal | Yes | 8.0 | 21.59 |
| 310 | CD | Cult Of Luna - Years In A Day | Metal | Post Metal | No | 40.0 | 20.50 |
| 123 | CD | Uneven Structure - 8 | Metal | Djent | No | 8.0 | 20.00 |
| 177 | CD | Alterbeast - Immortal | Metal | Technical Death Metal | Yes | 10.0 | 15.55 |
| 267 | CD | Saor - Guardians | Metal | Black Metal | Yes | 10.0 | 14.18 |
| 165 | CD | Saor - Aura | Metal | Black Metal | Yes | 10.0 | 13.33 |
| 76 | CD | Bongripper - The Great Barrier Reefer | Metal | Doom Metal | No | 5.0 | 13.16 |
| 38 | CD | Sólstafir - Köld | Metal | Post Metal | No | 5.0 | 12.78 |
| 101 | CD | Vestiges - The Descent Of Man | Metal | Black Metal | No | 8.0 | 12.68 |
| 94 | CD | The Ocean (2) - Pelagial | Metal | Post Metal | No | 12.0 | 12.50 |
| 158 | CD | Archspire - The Lucid Collective | Metal | Technical Death Metal | No | 7.0 | 11.94 |
| 36 | CD | Xasthur - All Reflections Drained | Metal | Black Metal | No | 2.0 | 11.92 |
| 168 | CD | Skyharbor - Guiding Lights | Metal | Djent | Yes | 30.0 | 11.83 |
| 62 | CD | Fallujah - The Harvest Wombs | Metal | Technical Death Metal | No | 10.0 | 11.49 |
| 64 | CD | Haken (2) - Visions | Metal | Progressive Metal | No | 10.0 | 11.11 |
| 65 | CD | Uneven Structure - Februus | Metal | Djent | No | 8.0 | 11.09 |
| 58 | CD | TesseracT - One | Metal | Djent | No | 11.0 | 11.00 |
| 150 | CD | Bongripper - Hippie Killer | Metal | Doom Metal | No | 5.0 | 10.49 |
| 18 | CD | Kayo Dot - Choirs Of The Eye | Metal | Progressive Metal | Yes | 15.0 | 10.19 |
| CollectionFolder | Record | Genre | Subgenre | Collection_Autographed | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|---|
| 203 | Vinyl | Ne Obliviscaris - Portal Of I | Metal | Progressive Metal | Yes | 30.0 | 50.00 | 77.81 | 250.00 |
| 202 | Vinyl | Leprous - Bilateral | Metal | Progressive Metal | Yes | 40.0 | 50.00 | 111.52 | 155.02 |
| 199 | Vinyl | Isis (6) - Oceanic | Metal | Post Metal | Yes | 22.0 | 29.00 | 49.49 | 109.89 |
| 142 | Vinyl | Haken (2) - The Mountain | Metal | Progressive Metal | Yes | 22.0 | 64.84 | 81.20 | 109.88 |
| 141 | Vinyl | Opeth - Heritage | Metal | Progressive Metal | Yes | 40.0 | 54.95 | 75.92 | 100.00 |
| 186 | Vinyl | The Contortionist (2) - Language | Metal | Djent | Yes | 15.0 | 17.00 | 65.11 | 89.95 |
| 139 | Vinyl | Leprous - Coal | Metal | Progressive Metal | Yes | 20.0 | 54.93 | 59.44 | 87.91 |
| 280 | Vinyl | Perturbator - The Uncanny Valley | Electronic | Outrun | Yes | 30.0 | 19.63 | 38.70 | 79.99 |
| 127 | Vinyl | Intronaut - Valley Of Smoke | Metal | Post Metal | Yes | 20.0 | 22.99 | 40.00 | 76.92 |
| 128 | Vinyl | Falls Of Rauros - The Light That Dwells In Rot... | Metal | Black Metal | Yes | 18.0 | 23.07 | 37.92 | 66.91 |
| 177 | CD | Alterbeast - Immortal | Metal | Technical Death Metal | Yes | 10.0 | 13.33 | 15.55 | 38.89 |
| 190 | CD | Son Of Aurelius - Under A Western Sun | Metal | Progressive Metal | Yes | 8.0 | 20.00 | 21.59 | 23.19 |
| 267 | CD | Saor - Guardians | Metal | Black Metal | Yes | 10.0 | 12.09 | 14.18 | 18.66 |
| 18 | CD | Kayo Dot - Choirs Of The Eye | Metal | Progressive Metal | Yes | 15.0 | 6.66 | 10.19 | 16.37 |
| 165 | CD | Saor - Aura | Metal | Black Metal | Yes | 10.0 | 8.89 | 13.33 | 15.38 |
| 168 | CD | Skyharbor - Guiding Lights | Metal | Djent | Yes | 30.0 | 10.00 | 11.83 | 14.86 |
| Released | Subgenre | Artist2 | Title | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|
| 0 | 1999 | Progressive Metal | 1 | 1 | 1.0 | 0.86 | 5.51 | 11.99 |
| 1 | 2002 | Post Metal | 1 | 1 | 7.0 | 4.58 | 6.33 | 12.97 |
| 2 | 2003 | Progressive Metal | 1 | 1 | 15.0 | 6.66 | 10.19 | 16.37 |
| 3 | 2004 | Post Metal | 1 | 1 | 7.0 | 4.55 | 9.91 | 11.99 |
| 4 | 2004 | Progressive Metal | 1 | 1 | 6.0 | 4.99 | 6.40 | 19.00 |
| Subgenre | Black Metal | Djent | Post Metal | Progressive Metal | Sludge Metal |
|---|---|---|---|---|---|
| Released | |||||
| 2016 | 194.0 | 28.0 | 285.0 | 197.0 | 36.0 |
| 2017 | 145.0 | 82.0 | 266.0 | 37.0 | 15.0 |
| 2018 | 207.0 | NaN | 79.0 | NaN | 75.0 |
| 2019 | 384.0 | NaN | 66.0 | 50.0 | NaN |
| 2020 | 36.0 | NaN | NaN | NaN | NaN |
| Subgenre | Black Metal | Djent | Post Metal | Progressive Metal | Sludge Metal |
|---|---|---|---|---|---|
| Released | |||||
| 2016 | 11.0 | 1.0 | 11.0 | 7.0 | 2.0 |
| 2017 | 8.0 | 3.0 | 9.0 | 2.0 | 1.0 |
| 2018 | 9.0 | NaN | 3.0 | NaN | 5.0 |
| 2019 | 19.0 | NaN | 1.0 | 2.0 | NaN |
| 2020 | 2.0 | NaN | NaN | NaN | NaN |
| Released | Genre | Artist2 | Title | Collection_Cost | _Min_ | _Median_ | _Max_ | |
|---|---|---|---|---|---|---|---|---|
| 0 | 1961 | Jazz | 1 | 1 | 20.0 | 5.07 | 26.50 | 130.00 |
| 1 | 1971 | Rock | 1 | 1 | 5.5 | 2.25 | 3.87 | 10.00 |
| 2 | 1973 | Rock | 2 | 2 | 10.5 | 11.94 | 23.48 | 40.00 |
| 3 | 1974 | Rock | 1 | 1 | 4.0 | 1.13 | 7.00 | 30.74 |
| 4 | 1975 | Rock | 1 | 1 | 12.0 | 10.00 | 17.00 | 25.00 |